﻿//using System;
//using System.Collections.Generic;
//using System.Linq;
//using System.Web;
//using System.Data.SqlClient;

//namespace Hotel2
//{
//    public class ConnWithSQL
//    {
//        public void dbinsert(string cycki)
//        { 
//            Sqlconnection con  = new Sqlconnection();
//            con.open  ();
//            con.Connectionstring = "Data Source=PHANNY-PC\PHANNY; Initial Catalog=db_stuRegisterPay; Integrated Security=SSPI";
//        string query = cycki;
//            //"insert into Persons_info(perID, latinName, gender, dob, pob, phone, passport, curAdd, status) values('" +
//            //txtID.Text + "','" + txtLatinName.Text + "','" + cbGender.Text + "'" + dTPdob.Text + txtPob.Text + "','" +
//            //txtPhone.Text + "','" + txtPassport.Text + "'" + txtCurAdd.Text + "'" + cbStatus.Text + " )";

//     //   SqlCommand cmd = new SqlCommand(query, con);
//       // cmd.ExecuteNonQuery ();

//        MessageBox.show("Saving is done!");
//    }
//}
//}